Overview

Dataset Statistics

Number of Variables 22
Number of Rows 11963
Missing Cells 0
Missing Cells (%) 0.0%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 2.0 MB
Average Row Size in Memory 176.0 B
Variable Types
  • Numerical: 15
  • Categorical: 7

Dataset Insights

time is skewed Skewed
orig_time is skewed Skewed
mat_time is skewed Skewed
balance_time is skewed Skewed
LTV_time is skewed Skewed
rate_time is skewed Skewed
hpi_time is skewed Skewed
gdp_time is skewed Skewed
LTV_orig_time is skewed Skewed
payoff_time has constant value "0" Constant
REtype_CO_orig_time has constant length 1 Constant Length
REtype_PU_orig_time has constant length 1 Constant Length
REtype_SF_orig_time has constant length 1 Constant Length
investor_orig_time has constant length 1 Constant Length
default_time has constant length 1 Constant Length
payoff_time has constant length 1 Constant Length
status_time has constant length 1 Constant Length
orig_time has 245 (2.05%) negatives Negatives
gdp_time has 1363 (11.39%) negatives Negatives
Interest_Rate_orig_time has 1459 (12.2%) zeros Zeros
  • 1
  • 2

Variables

index

numerical

Approximate Distinct Count 11963
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 308047.3719
Minimum 23
Maximum 616469
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • index is skewed right (γ1 = 0.016)

Quantile Statistics

Minimum 23
5-th Percentile 34180.7
Q1 156053.5
Median 310099
Q3 450816
95-th Percentile 584242
Maximum 616469
Range 616446
IQR 294762.5

Descriptive Statistics

Mean 308047.3719
Standard Deviation 176531.2735
Variance 3.1163e+10
Sum 3.6852e+09
Skewness 0.01603
Kurtosis -1.1619
Coefficient of Variation 0.5731

id

numerical

Approximate Distinct Count 11963
Approximate Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 24907.8381
Minimum 1
Maximum 49192
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • id is skewed right (γ1 = 0.0088)

Quantile Statistics

Minimum 1
5-th Percentile 3587.5
Q1 13605.5
Median 24800
Q3 35722.5
95-th Percentile 46100.1
Maximum 49192
Range 49191
IQR 22117

Descriptive Statistics

Mean 24907.8381
Standard Deviation 13502.25
Variance 1.8231e+08
Sum 2.9797e+08
Skewness 0.008759
Kurtosis -1.1071
Coefficient of Variation 0.5421

time

numerical

Approximate Distinct Count 46
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 52.2351
Minimum 13
Maximum 60
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • time is skewed left (γ1 = -0.7469)

Quantile Statistics

Minimum 13
5-th Percentile 36
Q1 43
Median 60
Q3 60
95-th Percentile 60
Maximum 60
Range 47
IQR 17

Descriptive Statistics

Mean 52.2351
Standard Deviation 9.4862
Variance 89.9886
Sum 624889
Skewness -0.7469
Kurtosis -0.7308
Coefficient of Variation 0.1816
  • time is not normally distributed (p-value 1.236231496765443e-24)
  • time has 17 outliers

orig_time

numerical

Approximate Distinct Count 62
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 22.0592
Minimum -40
Maximum 49
Zeros 19
Zeros (%) 0.2%
Negatives 245
Negatives (%) 2.0%
  • orig_time is skewed left (γ1 = -2.8116)

Quantile Statistics

Minimum -40
5-th Percentile 11
Q1 20
Median 24
Q3 26
95-th Percentile 28
Maximum 49
Range 89
IQR 6

Descriptive Statistics

Mean 22.0592
Standard Deviation 6.8347
Variance 46.7134
Sum 263894
Skewness -2.8116
Kurtosis 14.7912
Coefficient of Variation 0.3098
  • orig_time is not normally distributed (p-value 3.165059210994188e-11)
  • orig_time has 586 outliers

first_time

numerical

Approximate Distinct Count 36
Approximate Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 25.487
Minimum 1
Maximum 49
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • first_time is skewed left (γ1 = -0.612)

Quantile Statistics

Minimum 1
5-th Percentile 18
Q1 23
Median 26
Q3 29
95-th Percentile 31
Maximum 49
Range 48
IQR 6

Descriptive Statistics

Mean 25.487
Standard Deviation 4.3152
Variance 18.6207
Sum 304901
Skewness -0.612
Kurtosis 3.0913
Coefficient of Variation 0.1693
  • first_time is not normally distributed (p-value 4.82869696574548e-05)
  • first_time has 118 outliers

mat_time

numerical

Approximate Distinct Count 185
Approximate Unique (%) 1.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 141.1041
Minimum 29
Maximum 229
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • mat_time is skewed left (γ1 = -1.2781)

Quantile Statistics

Minimum 29
5-th Percentile 105
Q1 139
Median 143
Q3 147
95-th Percentile 161
Maximum 229
Range 200
IQR 8

Descriptive Statistics

Mean 141.1041
Standard Deviation 19.1143
Variance 365.3578
Sum 1.688e+06
Skewness -1.2781
Kurtosis 7.6954
Coefficient of Variation 0.1355
  • mat_time is not normally distributed (p-value 1.6058970010004306e-16)
  • mat_time has 1566 outliers

balance_time

numerical

Approximate Distinct Count 11787
Approximate Unique (%) 98.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 228237.7968
Minimum 0
Maximum 2.9541e+06
Zeros 15
Zeros (%) 0.1%
Negatives 0
Negatives (%) 0.0%
  • balance_time is skewed right (γ1 = 2.7545)

Quantile Statistics

Minimum 0
5-th Percentile 42197.57
Q1 96571.375
Median 170333.05
Q3 306372.61
95-th Percentile 573879.405
Maximum 2.9541e+06
Range 2.9541e+06
IQR 209801.235

Descriptive Statistics

Mean 228237.7968
Standard Deviation 194516.774
Variance 3.7837e+10
Sum 2.7304e+09
Skewness 2.7545
Kurtosis 17.4516
Coefficient of Variation 0.8523
  • balance_time is not normally distributed (p-value 5.823286436265156e-12)
  • balance_time has 445 outliers

LTV_time

numerical

Approximate Distinct Count 11693
Approximate Unique (%) 97.7%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 86.0999
Minimum 0
Maximum 616.9851
Zeros 15
Zeros (%) 0.1%
Negatives 0
Negatives (%) 0.0%
  • LTV_time is skewed right (γ1 = 0.1382)

Quantile Statistics

Minimum 0
5-th Percentile 36.7056
Q1 69.2707
Median 87.8578
Q3 107.0275
95-th Percentile 125.4075
Maximum 616.9851
Range 616.9851
IQR 37.7568

Descriptive Statistics

Mean 86.0999
Standard Deviation 27.6004
Variance 761.7794
Sum 1.03e+06
Skewness 0.1382
Kurtosis 11.4896
Coefficient of Variation 0.3206
  • LTV_time is not normally distributed (p-value 1.4820178737669783e-09)
  • LTV_time has 145 outliers

interest_rate_time

numerical

Approximate Distinct Count 1228
Approximate Unique (%) 10.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 5.765
Minimum 1
Maximum 19.75
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • interest_rate_time is skewed right (γ1 = 0.2011)

Quantile Statistics

Minimum 1
5-th Percentile 2
Q1 3.265
Median 6.125
Q3 7.375
95-th Percentile 9.74
Maximum 19.75
Range 18.75
IQR 4.11

Descriptive Statistics

Mean 5.765
Standard Deviation 2.4361
Variance 5.9348
Sum 68967.119
Skewness 0.2011
Kurtosis -0.4176
Coefficient of Variation 0.4226
  • interest_rate_time is not normally distributed (p-value 0.0016575671740339463)
  • interest_rate_time has 21 outliers

rate_time

numerical

Approximate Distinct Count 57
Approximate Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 4.5778
Minimum 1.67
Maximum 8.82
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • rate_time is skewed right (γ1 = 0.9343)

Quantile Statistics

Minimum 1.67
5-th Percentile 3.86
Q1 4.34
Median 4.64
Q3 4.86
95-th Percentile 5.15
Maximum 8.82
Range 7.15
IQR 0.52

Descriptive Statistics

Mean 4.5778
Standard Deviation 0.4738
Variance 0.2245
Sum 54764.48
Skewness 0.9343
Kurtosis 10.4135
Coefficient of Variation 0.1035
  • rate_time is not normally distributed (p-value 2.4324540754969235e-11)
  • rate_time has 417 outliers

hpi_time

numerical

Approximate Distinct Count 46
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 176.1005
Minimum 146.45
Maximum 226.29
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • hpi_time is skewed left (γ1 = -0.3662)

Quantile Statistics

Minimum 146.45
5-th Percentile 150.91
Q1 158.16
Median 189.82
Q3 189.82
95-th Percentile 189.82
Maximum 226.29
Range 79.84
IQR 31.66

Descriptive Statistics

Mean 176.1005
Standard Deviation 16.9193
Variance 286.2637
Sum 2.1067e+06
Skewness -0.3662
Kurtosis -1.4672
Coefficient of Variation 0.09608
  • hpi_time is not normally distributed (p-value 1.364026786411617e-23)

gdp_time

numerical

Approximate Distinct Count 46
Approximate Unique (%) 0.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 1.9318
Minimum -4.1467
Maximum 4.3201
Zeros 0
Zeros (%) 0.0%
Negatives 1363
Negatives (%) 11.4%
  • gdp_time is skewed left (γ1 = -2.3563)

Quantile Statistics

Minimum -4.1467
5-th Percentile -3.3395
Q1 1.6682
Median 2.8364
Q3 2.8364
95-th Percentile 2.8364
Maximum 4.3201
Range 8.4668
IQR 1.1682

Descriptive Statistics

Mean 1.9318
Standard Deviation 1.8083
Variance 3.2699
Sum 23109.7338
Skewness -2.3563
Kurtosis 4.4598
Coefficient of Variation 0.9361
  • gdp_time is not normally distributed (p-value 6.387554948155113e-24)
  • gdp_time has 1363 outliers

REtype_CO_orig_time

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB
  • The largest value (0) is over 13.4 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 1
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 13.4 times larger than the second largest value (1)
  • REtype_CO_orig_time has words of constant length

REtype_PU_orig_time

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB
  • The largest value (0) is over 6.67 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 6.67 times larger than the second largest value (1)
  • REtype_PU_orig_time has words of constant length

REtype_SF_orig_time

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB
  • The largest value (1) is over 1.55 times larger than the second largest value (0)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 1
2nd row 0
3rd row 1
4th row 1
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • The top 2 categories (1, 0) take over 50.0%
  • The largest value (1) is over 1.55 times larger than the second largest value (0)
  • REtype_SF_orig_time has words of constant length

investor_orig_time

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB
  • The largest value (0) is over 5.81 times larger than the second largest value (1)

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • The top 2 categories (0, 1) take over 50.0%
  • The largest value (0) is over 5.81 times larger than the second largest value (1)
  • investor_orig_time has words of constant length

FICO_orig_time

numerical

Approximate Distinct Count 361
Approximate Unique (%) 3.0%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 671.1194
Minimum 413
Maximum 828
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • FICO_orig_time is skewed left (γ1 = -0.3207)

Quantile Statistics

Minimum 413
5-th Percentile 545
Q1 627
Median 674
Q3 722
95-th Percentile 779
Maximum 828
Range 415
IQR 95

Descriptive Statistics

Mean 671.1194
Standard Deviation 69.224
Variance 4791.967
Sum 8.0286e+06
Skewness -0.3207
Kurtosis -0.3193
Coefficient of Variation 0.1031
  • FICO_orig_time is not normally distributed (p-value 0.0006262952800896584)
  • FICO_orig_time has 36 outliers

LTV_orig_time

numerical

Approximate Distinct Count 500
Approximate Unique (%) 4.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 79.2476
Minimum 50.1
Maximum 125
Zeros 0
Zeros (%) 0.0%
Negatives 0
Negatives (%) 0.0%
  • LTV_orig_time is skewed left (γ1 = -0.2658)

Quantile Statistics

Minimum 50.1
5-th Percentile 60.5
Q1 75
Median 80
Q3 80
95-th Percentile 95
Maximum 125
Range 74.9
IQR 5

Descriptive Statistics

Mean 79.2476
Standard Deviation 9.6686
Variance 93.4814
Sum 948038.8
Skewness -0.2658
Kurtosis 0.7223
Coefficient of Variation 0.122
  • LTV_orig_time is not normally distributed (p-value 1.7077647025288304e-23)
  • LTV_orig_time has 3535 outliers

Interest_Rate_orig_time

numerical

Approximate Distinct Count 860
Approximate Unique (%) 7.2%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Memory Size 186.9 KB
Mean 5.5604
Minimum 0
Maximum 19.75
Zeros 1459
Zeros (%) 12.2%
Negatives 0
Negatives (%) 0.0%
  • Interest_Rate_orig_time is skewed left (γ1 = -0.6324)

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 4.625
Median 6.25
Q3 7.375
95-th Percentile 9.35
Maximum 19.75
Range 19.75
IQR 2.75

Descriptive Statistics

Mean 5.5604
Standard Deviation 2.8792
Variance 8.2898
Sum 66518.748
Skewness -0.6324
Kurtosis -0.1818
Coefficient of Variation 0.5178
  • Interest_Rate_orig_time is not normally distributed (p-value 2.896758788668438e-06)
  • Interest_Rate_orig_time has 1550 outliers

default_time

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • The top 2 categories (0, 1) take over 50.0%
  • default_time has words of constant length

payoff_time

categorical

Approximate Distinct Count 1
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 0

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • payoff_time has words of constant length

status_time

categorical

Approximate Distinct Count 2
Approximate Unique (%) 0.0%
Missing 0
Missing (%) 0.0%
Memory Size 771.1 KB

Length

Mean 1
Standard Deviation 0
Median 1
Minimum 1
Maximum 1

Sample

1st row 0
2nd row 0
3rd row 0
4th row 0
5th row 1

Letter

Count 0
Lowercase Letter 0
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 11963
  • The top 2 categories (0, 1) take over 50.0%
  • status_time has words of constant length

Interactions

Correlations

Missing Values